package com.qfedu.yuxiaoer.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class BillExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public BillExample() {
        oredCriteria = new ArrayList<>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCostTypeIdIsNull() {
            addCriterion("cost_type_id is null");
            return (Criteria) this;
        }

        public Criteria andCostTypeIdIsNotNull() {
            addCriterion("cost_type_id is not null");
            return (Criteria) this;
        }

        public Criteria andCostTypeIdEqualTo(Integer value) {
            addCriterion("cost_type_id =", value, "costTypeId");
            return (Criteria) this;
        }

        public Criteria andCostTypeIdNotEqualTo(Integer value) {
            addCriterion("cost_type_id <>", value, "costTypeId");
            return (Criteria) this;
        }

        public Criteria andCostTypeIdGreaterThan(Integer value) {
            addCriterion("cost_type_id >", value, "costTypeId");
            return (Criteria) this;
        }

        public Criteria andCostTypeIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("cost_type_id >=", value, "costTypeId");
            return (Criteria) this;
        }

        public Criteria andCostTypeIdLessThan(Integer value) {
            addCriterion("cost_type_id <", value, "costTypeId");
            return (Criteria) this;
        }

        public Criteria andCostTypeIdLessThanOrEqualTo(Integer value) {
            addCriterion("cost_type_id <=", value, "costTypeId");
            return (Criteria) this;
        }

        public Criteria andCostTypeIdIn(List<Integer> values) {
            addCriterion("cost_type_id in", values, "costTypeId");
            return (Criteria) this;
        }

        public Criteria andCostTypeIdNotIn(List<Integer> values) {
            addCriterion("cost_type_id not in", values, "costTypeId");
            return (Criteria) this;
        }

        public Criteria andCostTypeIdBetween(Integer value1, Integer value2) {
            addCriterion("cost_type_id between", value1, value2, "costTypeId");
            return (Criteria) this;
        }

        public Criteria andCostTypeIdNotBetween(Integer value1, Integer value2) {
            addCriterion("cost_type_id not between", value1, value2, "costTypeId");
            return (Criteria) this;
        }

        public Criteria andReceivePayTypeIsNull() {
            addCriterion("receive_pay_type is null");
            return (Criteria) this;
        }

        public Criteria andReceivePayTypeIsNotNull() {
            addCriterion("receive_pay_type is not null");
            return (Criteria) this;
        }

        public Criteria andReceivePayTypeEqualTo(Integer value) {
            addCriterion("receive_pay_type =", value, "receivePayType");
            return (Criteria) this;
        }

        public Criteria andReceivePayTypeNotEqualTo(Integer value) {
            addCriterion("receive_pay_type <>", value, "receivePayType");
            return (Criteria) this;
        }

        public Criteria andReceivePayTypeGreaterThan(Integer value) {
            addCriterion("receive_pay_type >", value, "receivePayType");
            return (Criteria) this;
        }

        public Criteria andReceivePayTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("receive_pay_type >=", value, "receivePayType");
            return (Criteria) this;
        }

        public Criteria andReceivePayTypeLessThan(Integer value) {
            addCriterion("receive_pay_type <", value, "receivePayType");
            return (Criteria) this;
        }

        public Criteria andReceivePayTypeLessThanOrEqualTo(Integer value) {
            addCriterion("receive_pay_type <=", value, "receivePayType");
            return (Criteria) this;
        }

        public Criteria andReceivePayTypeIn(List<Integer> values) {
            addCriterion("receive_pay_type in", values, "receivePayType");
            return (Criteria) this;
        }

        public Criteria andReceivePayTypeNotIn(List<Integer> values) {
            addCriterion("receive_pay_type not in", values, "receivePayType");
            return (Criteria) this;
        }

        public Criteria andReceivePayTypeBetween(Integer value1, Integer value2) {
            addCriterion("receive_pay_type between", value1, value2, "receivePayType");
            return (Criteria) this;
        }

        public Criteria andReceivePayTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("receive_pay_type not between", value1, value2, "receivePayType");
            return (Criteria) this;
        }

        public Criteria andTypeAffiliationIsNull() {
            addCriterion("type_affiliation is null");
            return (Criteria) this;
        }

        public Criteria andTypeAffiliationIsNotNull() {
            addCriterion("type_affiliation is not null");
            return (Criteria) this;
        }

        public Criteria andTypeAffiliationEqualTo(Integer value) {
            addCriterion("type_affiliation =", value, "typeAffiliation");
            return (Criteria) this;
        }

        public Criteria andTypeAffiliationNotEqualTo(Integer value) {
            addCriterion("type_affiliation <>", value, "typeAffiliation");
            return (Criteria) this;
        }

        public Criteria andTypeAffiliationGreaterThan(Integer value) {
            addCriterion("type_affiliation >", value, "typeAffiliation");
            return (Criteria) this;
        }

        public Criteria andTypeAffiliationGreaterThanOrEqualTo(Integer value) {
            addCriterion("type_affiliation >=", value, "typeAffiliation");
            return (Criteria) this;
        }

        public Criteria andTypeAffiliationLessThan(Integer value) {
            addCriterion("type_affiliation <", value, "typeAffiliation");
            return (Criteria) this;
        }

        public Criteria andTypeAffiliationLessThanOrEqualTo(Integer value) {
            addCriterion("type_affiliation <=", value, "typeAffiliation");
            return (Criteria) this;
        }

        public Criteria andTypeAffiliationIn(List<Integer> values) {
            addCriterion("type_affiliation in", values, "typeAffiliation");
            return (Criteria) this;
        }

        public Criteria andTypeAffiliationNotIn(List<Integer> values) {
            addCriterion("type_affiliation not in", values, "typeAffiliation");
            return (Criteria) this;
        }

        public Criteria andTypeAffiliationBetween(Integer value1, Integer value2) {
            addCriterion("type_affiliation between", value1, value2, "typeAffiliation");
            return (Criteria) this;
        }

        public Criteria andTypeAffiliationNotBetween(Integer value1, Integer value2) {
            addCriterion("type_affiliation not between", value1, value2, "typeAffiliation");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIsNull() {
            addCriterion("payment_time is null");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIsNotNull() {
            addCriterion("payment_time is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeEqualTo(Date value) {
            addCriterion("payment_time =", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotEqualTo(Date value) {
            addCriterion("payment_time <>", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThan(Date value) {
            addCriterion("payment_time >", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("payment_time >=", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThan(Date value) {
            addCriterion("payment_time <", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThanOrEqualTo(Date value) {
            addCriterion("payment_time <=", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIn(List<Date> values) {
            addCriterion("payment_time in", values, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotIn(List<Date> values) {
            addCriterion("payment_time not in", values, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeBetween(Date value1, Date value2) {
            addCriterion("payment_time between", value1, value2, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotBetween(Date value1, Date value2) {
            addCriterion("payment_time not between", value1, value2, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andAmountIsNull() {
            addCriterion("amount is null");
            return (Criteria) this;
        }

        public Criteria andAmountIsNotNull() {
            addCriterion("amount is not null");
            return (Criteria) this;
        }

        public Criteria andAmountEqualTo(BigDecimal value) {
            addCriterion("amount =", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotEqualTo(BigDecimal value) {
            addCriterion("amount <>", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountGreaterThan(BigDecimal value) {
            addCriterion("amount >", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("amount >=", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountLessThan(BigDecimal value) {
            addCriterion("amount <", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("amount <=", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountIn(List<BigDecimal> values) {
            addCriterion("amount in", values, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotIn(List<BigDecimal> values) {
            addCriterion("amount not in", values, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("amount between", value1, value2, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("amount not between", value1, value2, "amount");
            return (Criteria) this;
        }

        public Criteria andStartTimeIsNull() {
            addCriterion("start_time is null");
            return (Criteria) this;
        }

        public Criteria andStartTimeIsNotNull() {
            addCriterion("start_time is not null");
            return (Criteria) this;
        }

        public Criteria andStartTimeEqualTo(Date value) {
            addCriterion("start_time =", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotEqualTo(Date value) {
            addCriterion("start_time <>", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeGreaterThan(Date value) {
            addCriterion("start_time >", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("start_time >=", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeLessThan(Date value) {
            addCriterion("start_time <", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeLessThanOrEqualTo(Date value) {
            addCriterion("start_time <=", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeIn(List<Date> values) {
            addCriterion("start_time in", values, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotIn(List<Date> values) {
            addCriterion("start_time not in", values, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeBetween(Date value1, Date value2) {
            addCriterion("start_time between", value1, value2, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotBetween(Date value1, Date value2) {
            addCriterion("start_time not between", value1, value2, "startTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNull() {
            addCriterion("end_time is null");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNotNull() {
            addCriterion("end_time is not null");
            return (Criteria) this;
        }

        public Criteria andEndTimeEqualTo(Date value) {
            addCriterion("end_time =", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotEqualTo(Date value) {
            addCriterion("end_time <>", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThan(Date value) {
            addCriterion("end_time >", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("end_time >=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThan(Date value) {
            addCriterion("end_time <", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThanOrEqualTo(Date value) {
            addCriterion("end_time <=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIn(List<Date> values) {
            addCriterion("end_time in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotIn(List<Date> values) {
            addCriterion("end_time not in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeBetween(Date value1, Date value2) {
            addCriterion("end_time between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotBetween(Date value1, Date value2) {
            addCriterion("end_time not between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion("remarks is null");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion("remarks is not null");
            return (Criteria) this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion("remarks =", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion("remarks <>", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion("remarks >", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion("remarks >=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion("remarks <", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion("remarks <=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLike(String value) {
            addCriterion("remarks like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotLike(String value) {
            addCriterion("remarks not like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksIn(List<String> values) {
            addCriterion("remarks in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotIn(List<String> values) {
            addCriterion("remarks not in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion("remarks between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion("remarks not between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andContractIdIsNull() {
            addCriterion("contract_id is null");
            return (Criteria) this;
        }

        public Criteria andContractIdIsNotNull() {
            addCriterion("contract_id is not null");
            return (Criteria) this;
        }

        public Criteria andContractIdEqualTo(Integer value) {
            addCriterion("contract_id =", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdNotEqualTo(Integer value) {
            addCriterion("contract_id <>", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdGreaterThan(Integer value) {
            addCriterion("contract_id >", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("contract_id >=", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdLessThan(Integer value) {
            addCriterion("contract_id <", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdLessThanOrEqualTo(Integer value) {
            addCriterion("contract_id <=", value, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdIn(List<Integer> values) {
            addCriterion("contract_id in", values, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdNotIn(List<Integer> values) {
            addCriterion("contract_id not in", values, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdBetween(Integer value1, Integer value2) {
            addCriterion("contract_id between", value1, value2, "contractId");
            return (Criteria) this;
        }

        public Criteria andContractIdNotBetween(Integer value1, Integer value2) {
            addCriterion("contract_id not between", value1, value2, "contractId");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andPicIsNull() {
            addCriterion("pic is null");
            return (Criteria) this;
        }

        public Criteria andPicIsNotNull() {
            addCriterion("pic is not null");
            return (Criteria) this;
        }

        public Criteria andPicEqualTo(String value) {
            addCriterion("pic =", value, "pic");
            return (Criteria) this;
        }

        public Criteria andPicNotEqualTo(String value) {
            addCriterion("pic <>", value, "pic");
            return (Criteria) this;
        }

        public Criteria andPicGreaterThan(String value) {
            addCriterion("pic >", value, "pic");
            return (Criteria) this;
        }

        public Criteria andPicGreaterThanOrEqualTo(String value) {
            addCriterion("pic >=", value, "pic");
            return (Criteria) this;
        }

        public Criteria andPicLessThan(String value) {
            addCriterion("pic <", value, "pic");
            return (Criteria) this;
        }

        public Criteria andPicLessThanOrEqualTo(String value) {
            addCriterion("pic <=", value, "pic");
            return (Criteria) this;
        }

        public Criteria andPicLike(String value) {
            addCriterion("pic like", value, "pic");
            return (Criteria) this;
        }

        public Criteria andPicNotLike(String value) {
            addCriterion("pic not like", value, "pic");
            return (Criteria) this;
        }

        public Criteria andPicIn(List<String> values) {
            addCriterion("pic in", values, "pic");
            return (Criteria) this;
        }

        public Criteria andPicNotIn(List<String> values) {
            addCriterion("pic not in", values, "pic");
            return (Criteria) this;
        }

        public Criteria andPicBetween(String value1, String value2) {
            addCriterion("pic between", value1, value2, "pic");
            return (Criteria) this;
        }

        public Criteria andPicNotBetween(String value1, String value2) {
            addCriterion("pic not between", value1, value2, "pic");
            return (Criteria) this;
        }

        public Criteria andBillSearchTypeIdIsNull() {
            addCriterion("bill_search_type_id is null");
            return (Criteria) this;
        }

        public Criteria andBillSearchTypeIdIsNotNull() {
            addCriterion("bill_search_type_id is not null");
            return (Criteria) this;
        }

        public Criteria andBillSearchTypeIdEqualTo(Integer value) {
            addCriterion("bill_search_type_id =", value, "billSearchTypeId");
            return (Criteria) this;
        }

        public Criteria andBillSearchTypeIdNotEqualTo(Integer value) {
            addCriterion("bill_search_type_id <>", value, "billSearchTypeId");
            return (Criteria) this;
        }

        public Criteria andBillSearchTypeIdGreaterThan(Integer value) {
            addCriterion("bill_search_type_id >", value, "billSearchTypeId");
            return (Criteria) this;
        }

        public Criteria andBillSearchTypeIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("bill_search_type_id >=", value, "billSearchTypeId");
            return (Criteria) this;
        }

        public Criteria andBillSearchTypeIdLessThan(Integer value) {
            addCriterion("bill_search_type_id <", value, "billSearchTypeId");
            return (Criteria) this;
        }

        public Criteria andBillSearchTypeIdLessThanOrEqualTo(Integer value) {
            addCriterion("bill_search_type_id <=", value, "billSearchTypeId");
            return (Criteria) this;
        }

        public Criteria andBillSearchTypeIdIn(List<Integer> values) {
            addCriterion("bill_search_type_id in", values, "billSearchTypeId");
            return (Criteria) this;
        }

        public Criteria andBillSearchTypeIdNotIn(List<Integer> values) {
            addCriterion("bill_search_type_id not in", values, "billSearchTypeId");
            return (Criteria) this;
        }

        public Criteria andBillSearchTypeIdBetween(Integer value1, Integer value2) {
            addCriterion("bill_search_type_id between", value1, value2, "billSearchTypeId");
            return (Criteria) this;
        }

        public Criteria andBillSearchTypeIdNotBetween(Integer value1, Integer value2) {
            addCriterion("bill_search_type_id not between", value1, value2, "billSearchTypeId");
            return (Criteria) this;
        }

        public Criteria andBelongIsNull() {
            addCriterion("belong is null");
            return (Criteria) this;
        }

        public Criteria andBelongIsNotNull() {
            addCriterion("belong is not null");
            return (Criteria) this;
        }

        public Criteria andBelongEqualTo(Integer value) {
            addCriterion("belong =", value, "belong");
            return (Criteria) this;
        }

        public Criteria andBelongNotEqualTo(Integer value) {
            addCriterion("belong <>", value, "belong");
            return (Criteria) this;
        }

        public Criteria andBelongGreaterThan(Integer value) {
            addCriterion("belong >", value, "belong");
            return (Criteria) this;
        }

        public Criteria andBelongGreaterThanOrEqualTo(Integer value) {
            addCriterion("belong >=", value, "belong");
            return (Criteria) this;
        }

        public Criteria andBelongLessThan(Integer value) {
            addCriterion("belong <", value, "belong");
            return (Criteria) this;
        }

        public Criteria andBelongLessThanOrEqualTo(Integer value) {
            addCriterion("belong <=", value, "belong");
            return (Criteria) this;
        }

        public Criteria andBelongIn(List<Integer> values) {
            addCriterion("belong in", values, "belong");
            return (Criteria) this;
        }

        public Criteria andBelongNotIn(List<Integer> values) {
            addCriterion("belong not in", values, "belong");
            return (Criteria) this;
        }

        public Criteria andBelongBetween(Integer value1, Integer value2) {
            addCriterion("belong between", value1, value2, "belong");
            return (Criteria) this;
        }

        public Criteria andBelongNotBetween(Integer value1, Integer value2) {
            addCriterion("belong not between", value1, value2, "belong");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("city is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("city is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("city =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("city <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("city >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("city >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("city <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("city <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("city like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("city not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("city in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("city not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("city between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("city not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andBillPayTypeIdIsNull() {
            addCriterion("bill_pay_type_id is null");
            return (Criteria) this;
        }

        public Criteria andBillPayTypeIdIsNotNull() {
            addCriterion("bill_pay_type_id is not null");
            return (Criteria) this;
        }

        public Criteria andBillPayTypeIdEqualTo(Integer value) {
            addCriterion("bill_pay_type_id =", value, "billPayTypeId");
            return (Criteria) this;
        }

        public Criteria andBillPayTypeIdNotEqualTo(Integer value) {
            addCriterion("bill_pay_type_id <>", value, "billPayTypeId");
            return (Criteria) this;
        }

        public Criteria andBillPayTypeIdGreaterThan(Integer value) {
            addCriterion("bill_pay_type_id >", value, "billPayTypeId");
            return (Criteria) this;
        }

        public Criteria andBillPayTypeIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("bill_pay_type_id >=", value, "billPayTypeId");
            return (Criteria) this;
        }

        public Criteria andBillPayTypeIdLessThan(Integer value) {
            addCriterion("bill_pay_type_id <", value, "billPayTypeId");
            return (Criteria) this;
        }

        public Criteria andBillPayTypeIdLessThanOrEqualTo(Integer value) {
            addCriterion("bill_pay_type_id <=", value, "billPayTypeId");
            return (Criteria) this;
        }

        public Criteria andBillPayTypeIdIn(List<Integer> values) {
            addCriterion("bill_pay_type_id in", values, "billPayTypeId");
            return (Criteria) this;
        }

        public Criteria andBillPayTypeIdNotIn(List<Integer> values) {
            addCriterion("bill_pay_type_id not in", values, "billPayTypeId");
            return (Criteria) this;
        }

        public Criteria andBillPayTypeIdBetween(Integer value1, Integer value2) {
            addCriterion("bill_pay_type_id between", value1, value2, "billPayTypeId");
            return (Criteria) this;
        }

        public Criteria andBillPayTypeIdNotBetween(Integer value1, Integer value2) {
            addCriterion("bill_pay_type_id not between", value1, value2, "billPayTypeId");
            return (Criteria) this;
        }

        public Criteria andDepartmentIsNull() {
            addCriterion("department is null");
            return (Criteria) this;
        }

        public Criteria andDepartmentIsNotNull() {
            addCriterion("department is not null");
            return (Criteria) this;
        }

        public Criteria andDepartmentEqualTo(String value) {
            addCriterion("department =", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentNotEqualTo(String value) {
            addCriterion("department <>", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentGreaterThan(String value) {
            addCriterion("department >", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentGreaterThanOrEqualTo(String value) {
            addCriterion("department >=", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentLessThan(String value) {
            addCriterion("department <", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentLessThanOrEqualTo(String value) {
            addCriterion("department <=", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentLike(String value) {
            addCriterion("department like", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentNotLike(String value) {
            addCriterion("department not like", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentIn(List<String> values) {
            addCriterion("department in", values, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentNotIn(List<String> values) {
            addCriterion("department not in", values, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentBetween(String value1, String value2) {
            addCriterion("department between", value1, value2, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentNotBetween(String value1, String value2) {
            addCriterion("department not between", value1, value2, "department");
            return (Criteria) this;
        }

        public Criteria andSignatoryIsNull() {
            addCriterion("signatory is null");
            return (Criteria) this;
        }

        public Criteria andSignatoryIsNotNull() {
            addCriterion("signatory is not null");
            return (Criteria) this;
        }

        public Criteria andSignatoryEqualTo(String value) {
            addCriterion("signatory =", value, "signatory");
            return (Criteria) this;
        }

        public Criteria andSignatoryNotEqualTo(String value) {
            addCriterion("signatory <>", value, "signatory");
            return (Criteria) this;
        }

        public Criteria andSignatoryGreaterThan(String value) {
            addCriterion("signatory >", value, "signatory");
            return (Criteria) this;
        }

        public Criteria andSignatoryGreaterThanOrEqualTo(String value) {
            addCriterion("signatory >=", value, "signatory");
            return (Criteria) this;
        }

        public Criteria andSignatoryLessThan(String value) {
            addCriterion("signatory <", value, "signatory");
            return (Criteria) this;
        }

        public Criteria andSignatoryLessThanOrEqualTo(String value) {
            addCriterion("signatory <=", value, "signatory");
            return (Criteria) this;
        }

        public Criteria andSignatoryLike(String value) {
            addCriterion("signatory like", value, "signatory");
            return (Criteria) this;
        }

        public Criteria andSignatoryNotLike(String value) {
            addCriterion("signatory not like", value, "signatory");
            return (Criteria) this;
        }

        public Criteria andSignatoryIn(List<String> values) {
            addCriterion("signatory in", values, "signatory");
            return (Criteria) this;
        }

        public Criteria andSignatoryNotIn(List<String> values) {
            addCriterion("signatory not in", values, "signatory");
            return (Criteria) this;
        }

        public Criteria andSignatoryBetween(String value1, String value2) {
            addCriterion("signatory between", value1, value2, "signatory");
            return (Criteria) this;
        }

        public Criteria andSignatoryNotBetween(String value1, String value2) {
            addCriterion("signatory not between", value1, value2, "signatory");
            return (Criteria) this;
        }

        public Criteria andLeaseButlerIsNull() {
            addCriterion("lease_butler is null");
            return (Criteria) this;
        }

        public Criteria andLeaseButlerIsNotNull() {
            addCriterion("lease_butler is not null");
            return (Criteria) this;
        }

        public Criteria andLeaseButlerEqualTo(String value) {
            addCriterion("lease_butler =", value, "leaseButler");
            return (Criteria) this;
        }

        public Criteria andLeaseButlerNotEqualTo(String value) {
            addCriterion("lease_butler <>", value, "leaseButler");
            return (Criteria) this;
        }

        public Criteria andLeaseButlerGreaterThan(String value) {
            addCriterion("lease_butler >", value, "leaseButler");
            return (Criteria) this;
        }

        public Criteria andLeaseButlerGreaterThanOrEqualTo(String value) {
            addCriterion("lease_butler >=", value, "leaseButler");
            return (Criteria) this;
        }

        public Criteria andLeaseButlerLessThan(String value) {
            addCriterion("lease_butler <", value, "leaseButler");
            return (Criteria) this;
        }

        public Criteria andLeaseButlerLessThanOrEqualTo(String value) {
            addCriterion("lease_butler <=", value, "leaseButler");
            return (Criteria) this;
        }

        public Criteria andLeaseButlerLike(String value) {
            addCriterion("lease_butler like", value, "leaseButler");
            return (Criteria) this;
        }

        public Criteria andLeaseButlerNotLike(String value) {
            addCriterion("lease_butler not like", value, "leaseButler");
            return (Criteria) this;
        }

        public Criteria andLeaseButlerIn(List<String> values) {
            addCriterion("lease_butler in", values, "leaseButler");
            return (Criteria) this;
        }

        public Criteria andLeaseButlerNotIn(List<String> values) {
            addCriterion("lease_butler not in", values, "leaseButler");
            return (Criteria) this;
        }

        public Criteria andLeaseButlerBetween(String value1, String value2) {
            addCriterion("lease_butler between", value1, value2, "leaseButler");
            return (Criteria) this;
        }

        public Criteria andLeaseButlerNotBetween(String value1, String value2) {
            addCriterion("lease_butler not between", value1, value2, "leaseButler");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusIsNull() {
            addCriterion("approval_status is null");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusIsNotNull() {
            addCriterion("approval_status is not null");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusEqualTo(Integer value) {
            addCriterion("approval_status =", value, "approvalStatus");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusNotEqualTo(Integer value) {
            addCriterion("approval_status <>", value, "approvalStatus");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusGreaterThan(Integer value) {
            addCriterion("approval_status >", value, "approvalStatus");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("approval_status >=", value, "approvalStatus");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusLessThan(Integer value) {
            addCriterion("approval_status <", value, "approvalStatus");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusLessThanOrEqualTo(Integer value) {
            addCriterion("approval_status <=", value, "approvalStatus");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusIn(List<Integer> values) {
            addCriterion("approval_status in", values, "approvalStatus");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusNotIn(List<Integer> values) {
            addCriterion("approval_status not in", values, "approvalStatus");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusBetween(Integer value1, Integer value2) {
            addCriterion("approval_status between", value1, value2, "approvalStatus");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("approval_status not between", value1, value2, "approvalStatus");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}